#! /bin/bash
join --nocheck-order <(join --nocheck-order <(awk '{arr[$1] += $2} END{for(x in arr){print x,arr[x]}}' ./pnames/project.zjsc  |sort -gk2|tail -80|sort) <(awk '{arr[$1] += $2} END{for(x in arr){print x,arr[x]}}' ./pnames/com.yunwang.kaixinxxl.cn  |sort -gk2|tail -80|sort) |awk '{diff=($2-$3)/$2; if(diff > 0.25 || diff < -0.25)print $0,diff}') <(sed 's/\./_/g' ./pname_sname.csv|sort)|sort -gk4
